1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Data;
5 using System.Drawing;
6 using System.Linq;
7 using System.Text;
8 using System.Windows.Forms;
9 using System.Data.SqlClient;
10 namespace WarehouseManagementSystem
11 {
12 public partial class frmLogin : Form
13 {
14 ConnectionString cs = new ConnectionString();
15 SqlDataReader rdr = null;
16 SqlConnection con = null;
17 SqlCommand cmd = null;
18 DataTable dt = new DataTable();
19 frmMainMenu frm = new frmMainMenu();
20 public frmLogin()
21 {
22 InitializeComponent();
23 }
24
25 private void btnOK_Click(object sender, EventArgs e)
26 {
27 if (txtUserName.Text == "")
28 {
29 MessageBox.Show("Please enter user name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
30 txtUserName.Focus();
31 return;
32 }
33 if (txtPassword.Text == "")
34 {
35 MessageBox.Show("Please enter password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
36 txtPassword.Focus();
37 return;
38 }
39 try
40 {
41 SqlConnection myConnection = default(SqlConnection);
42 myConnection = new SqlConnection(cs.DBConn);
43
44 SqlCommand myCommand = default(SqlCommand);
45
46 myCommand = new SqlCommand("SELECT Username,password FROM Registration WHERE Username = @username AND password = @UserPassword", myConnection);
47 SqlParameter uName = new SqlParameter("@username", SqlDbType.VarChar);
48 SqlParameter uPassword = new SqlParameter("@UserPassword", SqlDbType.VarChar);
49 uName.Value = txtUserName.Text;
50 uPassword.Value = txtPassword.Text;
51 myCommand.Parameters.Add(uName);
52 myCommand.Parameters.Add(uPassword);
53
54 myCommand.Connection.Open();
55
56 SqlDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
57
58 if (myReader.Read() == true)
59 {
60 int i;
61 ProgressBar1.Visible = true;
62 ProgressBar1.Maximum = 5000;
63 ProgressBar1.Minimum = 0;
64 ProgressBar1.Value = 4;
65 ProgressBar1.Step = 1;
66
67 for (i = 0; i <= 5000; i++)
68 {
69 ProgressBar1.PerformStep();
70 }
71 con = new SqlConnection(cs.DBConn);
72 con.Open();
73 string ct = "select usertype from Registration where Username='" + txtUserName.Text + "' and Password='" + txtPassword.Text + "'";
74 cmd = new SqlCommand(ct);
75 cmd.Connection = con;
76 rdr = cmd.ExecuteReader();
77 if (rdr.Read())
78 {
79 txtUserType.Text = (rdr.GetString(0));
80 }
81 if ((rdr != null))
82 {
83 rdr.Close();
84 }
85
86 if (txtUserType.Text.Trim()== "Admin")
87 {
88 this.Hide();
89
90 frm.masterEntryToolStripMenuItem.Enabled=true;
91 frm.usersToolStripMenuItem.Enabled=true;
92 frm.customerToolStripMenuItem1.Enabled=true;
93 frm.suppliersToolStripMenuItem.Enabled=true;
94 frm.productsToolStripMenuItem.Enabled=true;
95 frm.recordsToolStripMenuItem.Enabled=true;
96 frm.registrationToolStripMenuItem.Enabled=true;
97 frm.databaseToolStripMenuItem.Enabled=true;
98 frm.customerToolStripMenuItem.Enabled=true;
99 frm.supplierToolStripMenuItem.Enabled=true;
100 frm.productToolStripMenuItem.Enabled=true;
101 frm.stockToolStripMenuItem.Enabled=true;
102 frm.invoiceToolStripMenuItem.Enabled = true;
103 frm.Show();
104 frm.lblUser.Text = txtUserName.Text;
105 frm.lblUserType.Text = txtUserType.Text;
106 }
107 if (txtUserType.Text.Trim() == "Sales Person")
108 {
109 frm.masterEntryToolStripMenuItem.Enabled = false;
110 frm.usersToolStripMenuItem.Enabled = false;
111 frm.customerToolStripMenuItem1.Enabled = true;
112 frm.suppliersToolStripMenuItem.Enabled = false;
113 frm.productsToolStripMenuItem.Enabled = false;
114 frm.recordsToolStripMenuItem.Enabled = false;
115 frm.registrationToolStripMenuItem.Enabled = false;
116 frm.databaseToolStripMenuItem.Enabled = false;
117 frm.customerToolStripMenuItem.Enabled = true;
118 frm.supplierToolStripMenuItem.Enabled = false;
119 frm.productToolStripMenuItem.Enabled = false;
120 frm.stockToolStripMenuItem.Enabled = false;
121 frm.invoiceToolStripMenuItem.Enabled = true;
122 this.Hide();
123 frm.Show();
124 frm.lblUser.Text = txtUserName.Text;
125 frm.lblUserType.Text = txtUserType.Text;
126 }
127 if (txtUserType.Text.Trim() == "Warehouse Worker")
128 {
129 frm.masterEntryToolStripMenuItem.Enabled = false;
130 frm.usersToolStripMenuItem.Enabled = false;
131 frm.customerToolStripMenuItem1.Enabled = false;
132 frm.suppliersToolStripMenuItem.Enabled = false;
133 frm.productsToolStripMenuItem.Enabled = false;
134 frm.recordsToolStripMenuItem.Enabled = false;
135 frm.registrationToolStripMenuItem.Enabled = false;
136 frm.databaseToolStripMenuItem.Enabled = false;
137 frm.customerToolStripMenuItem.Enabled = false;
138 frm.supplierToolStripMenuItem.Enabled = false;
139 frm.productToolStripMenuItem.Enabled = false;
140 frm.stockToolStripMenuItem.Enabled = false;
141 frm.invoiceToolStripMenuItem.Enabled = false;
142 this.Hide();
143 frm.Show();
144 frm.lblUser.Text = txtUserName.Text;
145 frm.lblUserType.Text = txtUserType.Text;
146 }
147
148 if (txtUserType.Text.Trim() == "Warehouse Manager")
149 {
150 frm.masterEntryToolStripMenuItem.Enabled = false;
151 frm.usersToolStripMenuItem.Enabled = false;
152 frm.customerToolStripMenuItem1.Enabled = false;
153 frm.suppliersToolStripMenuItem.Enabled = false;
154 frm.productsToolStripMenuItem.Enabled = false;
155 frm.recordsToolStripMenuItem.Enabled = false;
156 frm.registrationToolStripMenuItem.Enabled = false;
157 frm.databaseToolStripMenuItem.Enabled = false;
158 frm.customerToolStripMenuItem.Enabled = false;
159 frm.supplierToolStripMenuItem.Enabled = true;
160 frm.productToolStripMenuItem.Enabled = true;
161 frm.stockToolStripMenuItem.Enabled = true;
162 frm.invoiceToolStripMenuItem.Enabled = false;
163 this.Hide();
164 frm.Show();
165 frm.lblUser.Text = txtUserName.Text;
166 frm.lblUserType.Text = txtUserType.Text;
167 }
168 if (txtUserType.Text.Trim() == "Customer")
169 {
170 frmCustomerMainMenu frm1 = new frmCustomerMainMenu();
171 this.Hide();
172 frm1.Show();
173 frm1.lblUser.Text = txtUserName.Text;
174 }
175 }
176 else
177 {
178 MessageBox.Show("Login is Failed...Try again !", "Login Denied", MessageBoxButtons.OK, MessageBoxIcon.Error);
179
180 txtUserName.Clear();
181 txtPassword.Clear();
182 txtUserName.Focus();
183
184 }
185 if (myConnection.State == ConnectionState.Open)
186 {
187 myConnection.Dispose();
188 }
189
190
191
192 }
193 catch (Exception ex)
194 {
195 MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
196 }
197 }
198
199 private void Form1_Load(object sender, EventArgs e)
200 {
201 ProgressBar1.Visible = false;
202 txtUserName.Focus();
203 }
204
205 private void btnCancel_Click(object sender, EventArgs e)
206 {
207 this.Dispose();
208
209 }
210
211 private void Form1_FormClosing(object sender, FormClosingEventArgs e)
212 {
213 this.Dispose();
214
215 }
216
217 private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
218 {
219 this.Hide();
220 frmChangePassword frm = new frmChangePassword();
221 frm.Show();
222 frm.txtUserName.Text = "";
223 frm.txtNewPassword.Text = "";
224 frm.txtOldPassword.Text = "";
225 frm.txtConfirmPassword.Text = "";
226 }
227
228
229 private void linkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
230 {
231 this.Hide();
232 frmCustomerRegistration frm = new frmCustomerRegistration();
233 frm.txtUsername.Text = "";
234 frm.txtPassword.Text = "";
235 frm.txtName.Text = "";
236 frm.txtContact_no.Text = "";
237 frm.txtEmail_Address.Text = "";
238 frm.txtUsername.Focus();
239 frm.Show();
240
241 }
242 }
243 }